home *** CD-ROM | disk | FTP | other *** search
/ The Macintosh Demo Applications CD / Apple-MacintoshDemoApplicationsCD-1.0-1992.bin / More Information / GQL V3.0 / Open ME! - USA Sales / Open ME! - USA Sales.rsrc / QRY_7535_Top Sales < prev    next >
Text File  |  1992-01-27  |  831b  |  1 lines
  1. 0100224080500salesmanstaff270000020010010005First Namefirst_namestaff270000030007009005Surnamelast_namestaff24080800works atworks at24060700officeoffices270020030006006007Regionregionoffices24040400soldsold24050600orderorders270040030006010006Amountord_amountorders140000020001140000030001140020030001140040030001130100000099 000146 000119 000156 00110500004003024«Enter sales threshold:»15260000010008salesman05staff08works at08works at260020010008works at08works at06office07offices260000030008salesman05staff04sold04sold260040030004sold04sold05order06orders1800400302200000252select staff.first_name, staff.last_name, offices.region, orders.ord_amount from staff, offices, orders where ((orders.ord_amount > «Enter sales threshold:»)) and staff.rep_office = offices.office_nr and staff.rep_nr = orders.salesrep order by 4 desc ;